CREATE TABLE Users(
	UserId			INT IDENTITY(1,1)	NOT NULL,
	Account			VARCHAR(50)			NOT NULL UNIQUE,
	[Password]		VARCHAR(50)			NOT NULL,
	RoleId			INT					NOT NULL,
	Email			VARCHAR(250)		NOT NULL UNIQUE,
	IsActive		BIT					NOT NULL DEFAULT(1),
	CONSTRAINT		PK_Users PRIMARY KEY(UserId)
)
GO

CREATE UNIQUE INDEX IX_Users_Account ON Users(Account)
GO

CREATE INDEX IX_Users_AccountAndPassword ON Users(Account, [Password])
GO

INSERT INTO Users(Account, [Password], RoleId, Email, IsActive)
VALUES ('admin', 'admin', 1, 'admin@sd.com', 1)
INSERT INTO Users(Account, [Password], RoleId, Email, IsActive)
VALUES ('admin2', 'admin2', 1, 'admin2@sd.com', 1)
